﻿USE lm_db;

insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (1,'test','shah satnaam ji dham','p',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'Y',null,1);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (2,'test2','SHAH MASTANA JI DHAM',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'Y',null,1);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (3,'ggn1','NaamCharcha Gurgaon',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'Y',null,2);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (4,'mh1','Shah Satnam Ji ParamSukh Ashram',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'Y',null,2);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (5,'mh2','Faltan Ahram',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (7,'21343214','ewqrewqr','Ashram','ewreqr','ewar','Ambala','Haryana','India',432,'324','Full Irrigation',25,245,'rthtr',432,'2012-11-01','aaaaaa',111,1111,111,'aaaa','','',null,'sss',11111,'','Initiated',0,null);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (8,'21343214','ewqrewqr','Ashram','ewreqr','ewar','Ambala','Haryana','India',432,'324','Full Irrigation',25,245,'rthtr',432,'2012-11-01','aaaaaa',111,1111,111,'aaaa','','','Yes','sss',11111,'','Initiated',0,null);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (9,'21343214','ewqrewqr','Ashram','ewreqr','ewar','Ambala','Haryana','India',432,'324','Full Irrigation',25,245,'eeee',432,'2012-11-01','aaaaaa',111,1111,111,'aaaa','','','Yes','sss',11111,'','Initiated',0,null);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (10,'21343214','ewqrewqr','Ashram','ewreqr','ewar','Ambala','Haryana','India',432,'324','Full Irrigation',25,245,'eeee',432,'2012-11-01','aaaaaa',111,1111,111,'aaaa','','','Yes','sss',11111,'','Initiated',0,null);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (11,'111','aaa','Ashram','qqqq','sssss','Bhiwani','Haryana','India',11,'111','Full Irrigation',1111,1111,'aaaa',11111,'2012-11-01','aaaaa',111111,12,23,'aewrew','','',null,'',121,', aaaa','',0,null);
insert into `location`(`LocationID`,`LocationCode`,`Name`,`Category`,`Address`,`Block`,`District`,`State`,`Country`,`LandArea`,`LandTerm`,`LandType`,`RunningFeet`,`CoveredArea`,`RegisteredOnName`,`RegistrationNo`,`RegistrationDate`,`SubRegistrar`,`EstimatedValue`,`StampExpenditure`,`OtherExpenditure`,`RegistryHolder`,`RegistryCopy`,`BuildingMap`,`Canteen`,`Landmark`,`DistanceFromMainRoad`,`ResponsiblePerson`,`Status`,`TotalBalance`,`GroupId`) values (12,'11111','asas','Ashram','cvcajh','jnkjn','Bhiwani','Haryana','Country',111111,'2222','Full Irrigation',1234,123,'aaaaa',111,'2012-01-25','kjhbj',11111,222,111,'asas','','','Yes','aaaa',1111,'MSG','Approved',0,null);
